package com.sharding.sphere.demo.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.sharding.sphere.demo.entity.Product;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * @author: shuguang.zhang
 * @date : 2021-06-05 21:53
 */
public interface ProductMapper extends BaseMapper<Product> {

    @Select("select * from t_product product left join t_product_price price ON product.product_no = price.product_no")
    List<Product> getAllProduct();
}
